﻿<?xml version="1.0" encoding="utf-8" ?>
<Verify>
  <Group type="Database" groupName="DM - Version Info in Database Validation">
    <!-- DiscoveryManager -->
    <Item name="EMC.EmailXtender.DiscoveryCollector.Version" server="[SQLServerInstance]" uid="[SQLServerUsername]" pwd="[SQLServerPassword]" dbName="DiscoveryManager" sqlQuery="SELECT Version FROM VersionInfo WHERE Name = 'EMC.EmailXtender.DiscoveryCollector'">[MajorVersion].[MinorVersion][BuildVersion]000</Item>
    <Item name="EMC.EmailXtender.DiscoveryCollector.VersionMajor" server="[SQLServerInstance]" uid="[SQLServerUsername]" pwd="[SQLServerPassword]" dbName="DiscoveryManager" sqlQuery="SELECT VersionMajor FROM VersionInfo WHERE Name = 'EMC.EmailXtender.DiscoveryCollector'">[MajorVersion]</Item>
    <Item name="EMC.EmailXtender.DiscoveryCollector.VersionMinor" server="[SQLServerInstance]" uid="[SQLServerUsername]" pwd="[SQLServerPassword]" dbName="DiscoveryManager" sqlQuery="SELECT VersionMinor FROM VersionInfo WHERE Name = 'EMC.EmailXtender.DiscoveryCollector'">[MinorVersion]</Item>
    <Item name="EMC.EmailXtender.DiscoveryCollector.BuildNumber" server="[SQLServerInstance]" uid="[SQLServerUsername]" pwd="[SQLServerPassword]" dbName="DiscoveryManager" sqlQuery="SELECT BuildNumber FROM VersionInfo WHERE Name = 'EMC.EmailXtender.DiscoveryCollector'">[RevisionVersion]</Item>
    <Item name="EMC.EmailXtender.DiscoveryCollector.VersionString" server="[SQLServerInstance]" uid="[SQLServerUsername]" pwd="[SQLServerPassword]" dbName="DiscoveryManager" sqlQuery="SELECT VersionString FROM VersionInfo WHERE Name = 'EMC.EmailXtender.DiscoveryCollector'">[MajorVersion].[MinorVersion][BuildVersion].[RevisionVersion]</Item>
    <Item name="EMC.EmailXtender.DiscoveryCollector.StoredProcs.Version" server="[SQLServerInstance]" uid="[SQLServerUsername]" pwd="[SQLServerPassword]" dbName="DiscoveryManager" sqlQuery="SELECT Version FROM VersionInfo WHERE Name = 'EMC.EmailXtender.DiscoveryCollector.StoredProcs'">[MajorVersion].[MinorVersion][BuildVersion]000</Item>
    <Item name="EMC.EmailXtender.DiscoveryCollector.StoredProcs.VersionMajor" server="[SQLServerInstance]" uid="[SQLServerUsername]" pwd="[SQLServerPassword]" dbName="DiscoveryManager" sqlQuery="SELECT VersionMajor FROM VersionInfo WHERE Name = 'EMC.EmailXtender.DiscoveryCollector.StoredProcs'">[MajorVersion]</Item>
    <Item name="EMC.EmailXtender.DiscoveryCollector.StoredProcs.VersionMinor" server="[SQLServerInstance]" uid="[SQLServerUsername]" pwd="[SQLServerPassword]" dbName="DiscoveryManager" sqlQuery="SELECT VersionMinor FROM VersionInfo WHERE Name = 'EMC.EmailXtender.DiscoveryCollector.StoredProcs'">[MinorVersion]</Item>
    <Item name="EMC.EmailXtender.DiscoveryCollector.StoredProcs.BuildNumber" server="[SQLServerInstance]" uid="[SQLServerUsername]" pwd="[SQLServerPassword]" dbName="DiscoveryManager" sqlQuery="SELECT BuildNumber FROM VersionInfo WHERE Name = 'EMC.EmailXtender.DiscoveryCollector.StoredProcs'">[RevisionVersion]</Item>
    <Item name="EMC.EmailXtender.DiscoveryCollector.StoredProcs.VersionString" server="[SQLServerInstance]" uid="[SQLServerUsername]" pwd="[SQLServerPassword]" dbName="DiscoveryManager" sqlQuery="SELECT VersionString FROM VersionInfo WHERE Name = 'EMC.EmailXtender.DiscoveryCollector.StoredProcs'">[MajorVersion].[MinorVersion][BuildVersion].[RevisionVersion]</Item>
  </Group>
</Verify>
